Computer Tutoring Limited

Microsoft Excel Advanced Training Course Cambridge

Course Duration: 1 Day

Office 365 User Training - All you need to know.

Course Highlights

• Gain proficiency in advanced formulas and functions, including an overview of common formulas and functions.
• Master the application of array functions, such as TOCOL(), UNIQUE, SEQUENCE, and the powerful LAMBDA function.
• Optimize your formulas using the LET function for enhanced efficiency and readability.
• Acquire data management skills by learning how to group, summarize, and analyze data across multiple sheets using SUMIF, COUNTIF, and other techniques.
• Explore advanced features of Power Query, including data unpivoting and applying Power Query steps for quick data transformations.

Training Benefits:

• Live Instructor Led Hands-on Training
• Free Post Training Support (1 Month Online Training / 3 Months Face to Face Training)
• Comprehensive Courseware
• Certificate of Completion

Training Rate Options:

All Inclusive Training Rate Options

A: Live Online Instructor Led Training
B: Clients Premises - Clients uses own laptops / PC
C: Cambourne Venue- Computer Tutoring laptops & Lunch

Training Venue

This 1 day course is available for training online, at your premises or at the local Cambridgeshire venue in Cambourne on a date suitable for you.

Enquire

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Private Microsoft Excel Classes 

To enquire about training courses please get in touch: info@computertutoring.co.uk 

Find out more

Microsoft Excel Intermediate Training Course Cambridge

Course Duration: 1 Day

Office 365 User Training - All you need to know.

Course Highlights

his Excel 365 intermediate training course will teach you the following:

• Using Lookup, Text, and Date functions along with the new array functions
• Pivot Tables and Pivot Charts
• Data Validation
• Conditional Formatting

Training Benefits:

• Live Instructor Led Hands-on Training
• Free Post Training Support (1 Month Online Training / 3 Months Face to Face Training)
• Comprehensive Courseware
• Certificate of Completion

Training Rate Options:

All Inclusive Training Rate Options

A: Live Online Instructor Led Training
B: Clients Premises - Clients uses own laptops / PC
C: Cambourne Venue- Computer Tutoring laptops & Lunch

Training Venue

This 1 day course is available for training online, at your premises or at the local Cambridgeshire venue in Cambourne on a date suitable for you.

Enquire

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Private Microsoft Excel Classes 

To enquire about training courses please get in touch: info@computertutoring.co.uk 

Find out more

Adobe InDesign Intermediate Training Course

Course Duration: 1 Day

Office 365 User Training - All you need to know.

Course Highlights

Using Master Pages in InDesign CC

• Using a master text frame
• Adding page numbers in InDesign
• Apply the Navigation Controls and Set Preferences

Changing the layout of a document

• Liquid Layout
• Gap tool

Templates in InDesign

• Creating custom Swatches
• Sharing templates

InDesign Mail Merge

• Choosing a data source
• Creating data merge fields

Creating shapes in InDesign

• Using the pathfinder tool
• Pen Tool
• Creating clipping masks
• How can creating text outlines help font accuracy?

Preparing for print

• Overprint preview
• Preflight profiles
• Crop Marks

Creating PDF Interactive Forms

• Determining the Page size
• Adding Form Elements (Text boxes, Checkboxes, Drop Down Lists)
• Submitting & Testing the form

Collaborating with Other applications

• Linked and Embedding images
• Accessing the layers within Photoshop & Illustrator images
• Adding extra information to the links window
• Mocking up a Website in InDesign

Useful InDesign tools

• Content Collector
• Gradient Feather Tool
• How to create a book in InDesign

Training Benefits:

• Live Instructor Led Hands-on Training
• Free Post Training Support (1 Month Online Training / 3 Months Face to Face Training)
• Comprehensive Courseware
• Certificate of Completion

Training Rate Options:

All Inclusive Training Rate Options

A: Live Online Instructor Led Training
B: Clients Premises - Clients uses own laptops / PC
C: Cambourne Venue- Computer Tutoring laptops & Lunch

Training Venue

This 1 day course is available for training online, at your premises or at the local Cambridgeshire venue in Cambourne on a date suitable for you.

Enquire

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Find out more

Microsoft Access Advanced Training Course Cambridge

Course Duration: 1 Day

Office 365 User Training - All you need to know.

Course Highlights

• Implement advanced form designs, including control settings, subforms, and conditional formatting.
• Execute comprehensive data validation at both the field and form levels.
• Create and utilise macros for enhanced user interface design, automation, and basic validation.
• Manage advanced database tasks such as linking to external data sources, object dependency tracking, and performance analysis.
• Secure and distribute databases effectively, including database splitting and implementing advanced security strategies.
• Enrol now to become a Microsoft Access 365 advanced user and take your database management skills to the next level.

Training Benefits:

• Live Instructor Led Hands-on Training
• Free Post Training Support (1 Month Online Training / 3 Months Face to Face Training)
• Comprehensive Courseware
• Certificate of Completion

Training Rate Options:

All Inclusive Training Rate Options

A: Live Online Instructor Led Training
B: Clients Premises - Clients uses own laptops / PC
C: Cambourne Venue- Computer Tutoring laptops & Lunch

Training Venue

This 1 day course is available for training online, at your premises or at the local Cambridgeshire venue in Cambourne on a date suitable for you.

Enquire

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Find out more

Microsoft PowerPoint Advanced Training Course

Course Duration: 1 Day

Office 365 User Training - All you need to know.

Course Highlights

• This PowerPoint 365 advanced training course will teach you the following:

• Work with Slide Masters and Layouts
• Create Master Slides
• Add Dynamic Content to your Presentations
• Deliver your Presentations Remotely
• Record your presentation

Training Benefits:

• Live Instructor Led Hands-on Training
• Free Post Training Support (1 Month Online Training / 3 Months Face to Face Training)
• Comprehensive Courseware
• Certificate of Completion

Training Rate Options:

All Inclusive Training Rate Options

A: Live Online Instructor Led Training
B: Clients Premises - Clients uses own laptops / PC
C: Cambourne Venue- Computer Tutoring laptops & Lunch

Training Venue

This 1 day course is available for training online, at your premises or at the local Cambridgeshire venue in Cambourne on a date suitable for you.

Enquire

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Find out more

Microsoft PowerPoint Advanced Training Cambridge

Course Duration: 1 Day

Office 365 User Training - All you need to know.

Course Highlights

This PowerPoint 365 advanced training course will teach you the following:

• Work with Slide Masters and Layouts
• Create Master Slides
• Add Dynamic Content to your Presentations
• Deliver your Presentations Remotely
• Record your presentation

Training Benefits:

• Live Instructor Led Hands-on Training
• Free Post Training Support (1 Month Online Training / 3 Months Face to Face Training)
• Comprehensive Courseware
• Certificate of Completion

Training Rate Options:

All Inclusive Training Rate Options

A: Live Online Instructor Led Training
B: Clients Premises - Clients uses own laptops / PC
C: Cambourne Venue- Computer Tutoring laptops & Lunch

Training Venue

This 1 day course is available for training online, at your premises or at the local Cambridgeshire venue in Cambourne on a date suitable for you.

Enquire

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Find out more

Course Highlights

Microsoft Visio Advanced Training Course Cambridge

Microsoft Visio 365 is Microsoft's premier diagramming application. This Visio 365 advanced course is designed for those who are already familiar with the basics of Microsoft Visio and wish to delve into its more complex functionalities. 

What You Will Learn How To:

• Enhance the Look of Drawings: Master the use of shape styles, 3D shapes, stencils, templates, and background management.
• Create Shapes, Stencils, and Templates: Learn how to create custom stencils, shapes, master shapes, and custom templates for unique diagramming needs.
• Connect Drawings to External Data: Discover methods to connect your Visio drawings to external data sources like Microsoft Excel worksheets, Microsoft Project files, and Microsoft Access databases.
• Leverage Development Tools: Get introduced to Visio''s development tools, including macros, ShapeSheets, and advanced shape creation tools.
• Share Drawings: Understand how to share your drawings effectively, covering topics such as OneDrive, reviewing, inserting into other Microsoft Office applications, exporting, and printing.

Training Benefits:

• Live Instructor Led Hands-on Training
• Free Post Training Support (1 Month Online Training / 3 Months Face to Face Training)
• Comprehensive Courseware
• Certificate of Completion

Training Rate Options:

All Inclusive Training Rate Options

A: Live Online Instructor Led Training
B: Clients Premises - Clients uses own laptops / PC
C: Cambourne Venue- Computer Tutoring laptops & Lunch

Training Venue

This 1 day course is available for training online, at your premises or at the local Cambridgeshire venue in Cambourne on a date suitable for you.

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Find out more

Microsoft Project Advanced Training Course Cambridge

Elevate Your Project Management Skills to the Next Level with this Microsoft Project 365 Advanced Training Course

Course Highlights

By the end of this course, students will learn to:

• Link multiple projects and create resource pools for optimised resource management.
• Establish and work with project baselines.
• Personalise project settings and work with custom fields.
• Alter task lists and oversee a project’s critical path.
• Design and personalise project views, including the Timeline view.
• Produce a range of reports, both built-in and bespoke, and export them to Microsoft Excel and Visio.

Training Rate Options:

All Inclusive Training Rate Options

A: Live Online Instructor Led Training
B: Clients Premises - Clients uses own laptops / PC
C: Cambourne Venue- Computer Tutoring laptops & Lunch

Training Benefits:

• Live Instructor Led Hands-on Training
• Free Post Training Support (1 Month Online Training / 3 Months Face to Face Training)
• Comprehensive Courseware
• Certificate of Completion

Training Venue

This 1 day course is available for training online, at your premises or at the local Cambridgeshire venue in Cambourne on a date suitable for you.

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Find out more

In today's fast-paced work environment, effective project management is more critical than ever. Microsoft Project 365 stands as one of the leading tools for orchestrating simple to complex projects. Our comprehensive Microsoft Project 365 beginners course is designed to equip you with the essential skills you need to manage projects like a pro.

Starting a Project:

Our course kicks off with the fundamentals. Learn the principles of Project Management 101, get acquainted with the Microsoft Project 365 interface, and discover how to add tasks and resources to your project. We ensure you build a strong foundation before diving into more advanced topics.

Working with Project Calendars:

Understanding timelines is vital in project management. In this module, you'll learn how to manage your project’s time frames effectively and modify working hours to suit your team’s needs.

Working with Project Tasks:

Tasks are the backbone of any project. This lesson provides in-depth insights into task management. You'll learn how to add summary tasks and milestones, making your project tracking more robust and intuitive.

Working with Project Resources:

Managing resources is just as crucial as managing time. This section delves into resource allocation, ensuring you understand how to allocate and level your work resources efficiently.

Delivering a Project Plan:

The ultimate goal is to deliver a successful project. Our final lesson outlines the steps for sharing and exporting your project plans, as well as printing different project views for stakeholder presentations.

Join us and master the art of project management with Microsoft Project. Whether you're a beginner or looking to enhance your skills, this course is tailored to bring your project management capabilities to the next level.

We look forward to helping you become proficient in Microsoft Project!

During this 1 day course you will learn how to:

• Start a Project
• Work with Project Calendars
• Work with Project Tasks
• Work with Project Resources
• Deliver a Project Plan

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Find out more

SharePoint is a collaboration platform that allows multiple users to share documents, exchange ideas, and work together. Microsoft SharePoint 365 takes these features even further, with integration with Microsoft 365 services. This SharePoint 365 training course is intended to help SharePoint users understand how to create and manage sites. We will cover the user interface; show users how to create new sites, libraries, lists, apps, and pages; and change site settings and manage site options. We will also provide a brief user’s guide to help administrators train site users.

What You Will Learn:

• How to create and customise SharePoint sites, enhancing them with various elements.
• Configuring and creating document libraries, apps, lists, and pages for an
• organized and functional SharePoint environment.
• Mastering site settings to optimise search functions, navigation, administration, and security measures.
• Understand and modify regional settings, access site usage data, and manage site permissions.
• Navigational skills and best practices for document libraries, including file management, versioning, and sharing features.

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Find out more

Microsoft Visio 365 has revolutionised diagram and flowchart design, streamlining the entire process for enhanced clarity and efficiency. With an array of templates and icons, Microsoft Visio enables the arrangement of complex data into easily understandable visuals such as flowcharts, floor plans, and more. By the end of this comprehensive course, delegates will be proficient in using Visio 365 for day-to-day tasks, and capable of creating organisation charts, floor plans, cross-functional flowcharts, and network diagrams.

On completion of the course delegates will be able to:

• Create a Workflow Diagram
• Create an Organisation Chart
• Make a Floor Plan
• Create a Cross-Functional Flowchart
• Create a Network Diagram
• Style a Diagram

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Find out more

Microsoft Forms and Excel User Training Beginners Cambridge

Course Duration: 1 Day

Office 365 User Training - All you need to know.

Course Highlights

Use Microsoft Forms to:

• Creating a Form
• Add Form Components
• Change Form Options
• Share your Form
• Handle Form Responses

Use Microsoft Excel to:

• Generate Pivot Charts & Tables
• Use VLOOKUP, XLOOKUP, IF and SUMIF Functions

Link Forms with Excel

• Create and Store a Form that links in Real Time to Excel

Training Benefits:

• Live Instructor Led Hands-on Training
• Free Post Training Support (1 Month Online Training / 3 Months Face to Face Training)
• Comprehensive Courseware
• Certificate of Completion

Training Rate Options:

All Inclusive Training Rate Options

A: Live Online Instructor Led Training
B: Clients Premises - Clients uses own laptops / PC
C: Cambourne Venue- Computer Tutoring laptops & Lunch

Training Venue

This 1 day course is available for training online, at your premises or at the local Cambridgeshire venue in Cambourne on a date suitable for you.

Enquire by sending an email to info@computertutoring.co.uk or by submitting an Enquiry. 

Find out more